package com.atguigu.phoneinteceptor.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper{

	
	public static final String TABLE_BLACK_INFO = "black_info";
	
	public DBHelper(Context context) {
		super(context, "phone_filter.db", null, 1);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL("create table black_info(_id integer PRIMARY KEY AUTOINCREMENT,number,name,type integer)");
		db.execSQL("insert into black_info (number, name, type) values ('1103', 'FJ3', 0)");
		db.execSQL("insert into black_info (number, name, type) values ('1104', 'FJ4', 0)");
		db.execSQL("insert into black_info (number, name, type) values ('1105', 'FJ5', 2)");
		db.execSQL("insert into black_info (number, name, type) values ('1106', 'FJ6', 0)");
		db.execSQL("insert into black_info (number, name, type) values ('1107', 'FJ7', 1)");
		db.execSQL("insert into black_info (number, name, type) values ('1108', 'FJ8', 0)");
		db.execSQL("insert into black_info (number, name, type) values ('1109', 'FJ9', 1)");
		db.execSQL("insert into black_info (number, name, type) values ('1100', 'FJ0', 2)");
		db.execSQL("insert into black_info (number, name, type) values ('1102', 'FJ2', 0)");
		db.execSQL("insert into black_info (number, name, type) values ('110', 'FJ', 0)");
		db.execSQL("insert into black_info (number, name, type) values ('119', 'HJ', 1)");
		db.execSQL("insert into black_info (number, name, type) values ('122', 'JJ', 2)");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		
	}
}
